home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
SPREOTUS
/
SYMWKS1.LZH
/
SYMQ&A.TXT
< prev
next >
Wrap
Text File
|
1984-11-25
|
13KB
|
423 lines
Hotline Q & A
SYMPHONY
The following are answers to questions commonly asked by our
dealers and test sites about Symphony's capabilities.
FILE HANDLING
Q. When I do a File Retrieve, the file name extensions are .WRK
for both worksheet and document files. Am I doing File Save
correctly?
A. Yes. Symphony gives the .WRK file name extension to both
spreadsheets and documents. As does 1-2-3, Symphony uses .PIC
and .PRN file name extensions to indicate graph-image and print
files respectively.
Q. When accessing a directory through File Retrieve or File Save,
[23;1H[J
Key S or <ENTER> to continue[23;30H!s
[23;1H[J the ESC key does not erase the current directory.
A. To erase the current directory name, simply press [ESC] twice.
This allows you to type in the name of another sub-directory.
WORD PROCESSING
Q. In a DOC window, there are times when word wrap doesn't seem to
work. Why?
A. Word wrap is disabled when overstrike INS is turned on, or when
justification is set to NONE. Press [INSERT] to turn off
overstrike mode or change the justification in the format line.
Q. Why are non-left aligned labels considered to be non-text,
i.e., why can't they be edited in word processing?
A. Centered (^) and right-aligned labels (") use leading spaces.
The Symphony program would need to be significantly larger to
handle these labels as text.
Q. Values entered in a SHEET window cannot be edited in a DOC
window.
A. True. The worksheet values you entered in SHEET are protected.
SPREADSHEET
Q. When printing spreadsheets, long labels are truncated at the
column width.
A. True. When defining an output range, the entire visible
portion of the labels must be highlighted.
Q. Where are the global options?
A. Press [Menu] and select Settings to establish column width,
recalculation mode, label prefix, etc.
Q. How do I transfer a row to a column without using DIF?
A. Use Symphony's new Range Transpose command.
Q. Will there be a function for TIME calculation?
A. There are several. @TIME returns the serial value of a time of
day. @TIMEVALUE returns a serial value of a time entered as a
string. There are also @HOUR, @MINUTE, and @SECOND, which will
accept a serial value, and return the corresponding time value.
Q. I'm using the range name "1st" in my worksheet, but Symphony
will not allow me to use @ functions involving that range.
A. Correct. For computational purposes, range names cannot begin
with a number, but Symphony will accept a range name like "1st"
for move, erase, and copy commands.
GRAPHING
Q. How do I explode the Pie Charts?
A. By assigning a B range for the graph settings, and giving a
value of 100 to 107 to the section you want exploded.
Q. How do I do a log/semi-log scale graph?
A. By hitting the daily double at Aqueduct! But
seriously...Symphony has built this into its graph
capabilities. Select Graph 2nd Settings X-Axis Type
Logarithmic. Do the same for the Y-Axis if appropriate.
FORMS/DATABASE
Q. What is the parse review range?
A. This is an area that Symphony uses to store any data that does
not match the criteria established by a form definition. An
example of such data would be the salutation and login sequence
which remains on the screen during a communications session
with a mainframe.
Q. Has the Data Distribution command been eliminated from
Symphony?
A. Not at all. It can now be found under Range Distribution.
Q. I'm creating a mailing list with Symphony, but it will not
accept the part of the formula I've used to reference zip
codes.
A. Symphony's string handling capabilities are one of its nicest
features, but it still sees numbers the same way as 1-2-3 does.
To create a formula that involves columns of numbers as well as
text, use the @STRING function for any numerical data.
COMMUNICATIONS
Q. Symphony's Settings Name Phone-and-Login sequence doesn't work
with my Hayes Smartmodem 1200.
A. Check to be sure that dip-switch number six is set to ON -- the
up position.
Q. Why does my monitor display two characters for every one I
strike?
A. Check your COMM Settings Sheet to be sure that Echo is set to
OFF.
Q. When I dial a remote computer, I hear the phone ring, and I
hear the high pitched sound that indicates that I've reached
the computer, but I can't connect.
A. You're transmitting at different baud rates. Find out the baud
rate of the computer you're trying to access and adjust your
own baud rate accordingly -- probably downward. The two most
common baud rates between computers are 300 and 1200.
SYMPHONY COMMAND LANGUAGE
Q. Can I turn my screen off while the macro is executing?
A. Yes. The new {paneloff} command will surpress the display of
the control panel, and the {windowsoff} command will supress
the window displays.
Hotline Q & A
SYMPHONY
The following are answers to questions commonly asked by our
dealers and test sites about Symphony's capabilities.
FILE HANDLING
Q. When I do a File Retrieve, the file name extensions are .WRK
for both worksheet and document files. Am I doing File Save
correctly?
A. Yes. Symphony gives the .WRK file name extension to both
spreadsheets and documents. As does 1-2-3, Symphony uses .PIC
and .PRN file name extensions to indicate graph-image and print
files respectively.
Q. When accessing a directory through File Retrieve or File Save, the ESC
key does not erase the current directory.
A. To erase the current directory name, simply press [ESC] twice.
This allows you to type in the name of another sub-directory.
WORD PROCESSING
Q. In a DOC window, there are times when word wrap doesn't seem to
work. Why?
A. Word wrap is disabled when overstrike INS is turned on, or when
justification is set to NONE. Press [INSERT] to turn off
overstrike mode or change the justification in the format line.
Q. Why are non-left aligned labels considered to be non-text,
i.e., why can't they be edited in word processing?
A. Centered (^) and right-aligned labels (") use leading spaces.
The Symphony program would need to be significantly larger to
handle these labels as text.
Q. Values entered in a SHEET window cannot be edited in a DOC
window.
A. True. The worksheet values you entered in SHEET are protected.
SPREADSHEET
Q. When printing spreadsheets, long labels are truncated at the
column width.
A. True. When defining an output range, the entire visible
portion of the labels must be highlighted.
Q. Where are the global options?
A. Press [Menu] and select Settings to establish column width,
recalculation mode, label prefix, etc.
Q. How do I transfer a row to a column without using DIF?
A. Use Symphony's new Range Transpose command.
Q. Will there be a function for TIME calculation?
A. There are several. @TIME returns the serial value of a time of
day. @TIMEVALUE returns a serial value of a time entered as a
string. There are also @HOUR, @MINUTE, and @SECOND, which will
accept a serial value, and return the corresponding time value.
Q. I'm using the range name "1st" in my worksheet, but Symphony
will not allow me to use @ functions involving that range.
A. Correct. For computational purposes, range names cannot begin
with a number, but Symphony will accept a range name like "1st"
for move, erase, and copy commands.
GRAPHING
Q. How do I explode the Pie Charts?
A. By assigning a B range for the graph settings, and giving a
value of 100 to 107 to the section you want exploded.
Q. How do I do a log/semi-log scale graph?
A. By hitting the daily double at Aqueduct! But
seriously...Symphony has built this into its graph
capabilities. Select Graph 2nd Settings X-Axis Type
Logarithmic. Do the same for the Y-Axis if appropriate.
FORMS/DATABASE
Q. What is the parse review range?
A. This is an area that Symphony uses to store any data that does
not match the criteria established by a form definition. An
example of such data would be the salutation and login sequence
which remains on the screen during a communications session
with a mainframe.
Q. Has the Data Distribution command been eliminated from
Symphony?
A. Not at all. It can now be found under Range Distribution.
Q. I'm creating a mailing list with Symphony, but it will not
accept the part of the formula I've used to reference zip
codes.
A. Symphony's string handling capabilities are one of its nicest
features, but it still sees numbers the same way as 1-2-3 does.
To create a formula that involves columns of numbers as well as
text, use the @STRING function for any numerical data.
COMMUNICATIONS
Q. Symphony's Settings Name Phone-and-Login sequence doesn't work
with my Hayes Smartmodem 1200.
A. Check to be sure that dip-switch number six is set to ON -- the
up position.
Q. Why does my monitor display two characters for every one I
strike?
A. Check your COMM Settings Sheet to be sure that Echo is set to
OFF.
Q. When I dial a remote computer, I hear the phone ring, and I
hear the high pitched sound that indicates that I've reached
the computer, but I can't connect.
A. You're transmitting at different baud rates. Find out the baud
rate of the computer you're trying to access and adjust your
own baud rate accordingly -- probably downward. The two most
common baud rates between computers are 300 and 1200.
SYMPHONY COMMAND LANGUAGE
Q. Can I turn my screen off while the macro is executing?
A. Yes. The new {paneloff} command will surpress the display of
the control panel, and the {windowsoff} command will supress
the window displays.